<%@page contentType="text/html"
    language="java"
    import="java.util.*"
    pageEncoding="UTF-8"%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
 <head>
 <title>Advert Table</title>
<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/prototype/1.6.1.0/prototype.js"></script>
<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/scriptaculous/1.8.2/scriptaculous.js"></script>
<script src="./js/rico.js" type="text/javascript"></script>
<script type='text/javascript'>Rico.acceptLanguage('en-us,en;q=0.5');</script>
<script type='text/javascript'>
Rico.loadModule('Effect','LiveGridAjax','LiveGridMenu','greenHdg.css');

var ex3,buffer;

Rico.onLoad( function() {
 // filterUI='t' --> text box
 // filterUI='s' --> select list
 var grid_options = {
   prefetchBuffer:true,
   frozenColumns:0,
   canFilterDefault:false,  // turn off filter menu items
   FilterLocation:  -1,     // put filter on a new header row
   saveColumnInfo: {width:true, filter:true, sort:true},
   columnSpecs:[
       {filterUI:'t'}, // accwareCode
       {filterUI:'t'}, // mfrName
       {filterUI:'t'}, // mfrNumber
       {canSort:false}, // upc
       {filterUI:'t'}, // vendor alias
       {canSort:false}, //conditions
       {canSort:false,type:'number',decPlaces:0}, // quantity
       {canSort:false,type:'number',prefix:'$',decPlaces:2}, // costPrice
       {canSort:false,type:'number',prefix:'$',decPlaces:2},  // sellPrice
       {canSort:false}, //grabber
       {canSort:false}, //bizrate
       {canSort:false}, //nexttag
       {canSort:false}  //shopping
   ]
  };
  buffer=new Rico.Buffer.AjaxSQL('advertable');
  ex3=new Rico.LiveGrid ('ex3', buffer, grid_options);
  ex3.menu=new Rico.GridMenu();
});
</script>

<style type="text/css">
input, select {
 font-weight:normal;
 font-size:8pt;
}
tr.ex3_hdg2 div.ricoLG_cell {
 height:1.4em;
 text-align:left;
 background-color:#deeecd;
}
.ricoLG_cell {
 white-space: nowrap;
}
</style>
</head>
<body>

<p class="ricoBookmark">
 <span id='ex3_timer' class='ricoSessionTimer'></span>
 <a id='ex3_filterLink' href="#"></a>
 <span id="ex3_bookmark">&nbsp;</span>
</p>
<table id="ex3" class="ricoLiveGrid" cellspacing="0" cellpadding="0">
<colgroup>
 <col style='width:125px;'>
 <col style='width:130px;'>
 <col style='width:130px;'>
 <col style='width:105px;'>
 <col style='width:100px;'>
 <col style='width:105px;'>
 <col style='width:60px;'>
 <col style='width:80px;'>
 <col style='width:80px;'>
 <col style='width:60px;'>
 <col style='width:60px;'>
 <col style='width:60px;'>
 <col style='width:60px;'>
</colgroup>

<thead>
<%-- <tr>
  <th class='ricoFrozen'>ID</th>
  <th>ID</th>
  <th colspan='3'>Shipment</th>
  <th colspan='3'>Date</th>
 </tr>--%>

 <tr id='ex3_main'>
  <th>AccwareCode</th>
  <th>Mfr Name</th>
  <th>Mfr Number</th>
  <th>UPC</th>
  <th>Vendor</th>
  <th>Conditions</th>
  <th>Qty</th>
  <th>Cost Price</th>
  <th>Sell Price</th>
  <th>grabber</th>
  <th>bizrate</th>
  <th>nextag</th>
  <th>shoping</th>
  </tr>
</thead>
</table>


 </body>
</html>
